Views [dbo].[vSoaPartyEventAvailability]
SQLServer > iMIS1521GA > Views > dbo.vSoaPartyEventAvailability
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Created10:34:48 AM Monday, January 09, 2012
Last Modified10:34:48 AM Monday, January 09, 2012
Columns
Name
PartyEventAvailabilityId
PartyId
EventId
SQL Script
CREATE
VIEW [dbo].[vSoaPartyEventAvailability]
AS
SELECT
    party.[PartyId] + ':' + eventSummary.[EventId] as [PartyEventAvailabilityId],
    party.[PartyId],
    eventSummary.[EventId]
FROM [dbo].[vSoaPartySummary] party
CROSS JOIN [dbo].[vSoaEventSummary] eventSummary
GO
Uses
Created 05 April 2012 11:11
Copyright  2012 - All Rights Reserved